[ROOT] dt DimEmployee < WHERE ParentEmployeeId EQ '7' >
8 items
| DimEmployeeId | BaseRate | BirthDate | Department | EmailAddress | EmergencyContactName | EmergencyContactPhone | EmployeeNationalIDAlternateKey | FirstName | Gender | HireDate | LastName | LoginID | MaritalStatus | MiddleName | ParentEmployeeId | PayFrequency | Phone | Photo | SickLeaveHours | StartDate | Status | Title | VacationHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 13.4615 | 1998-05-26 | Marketing | kevin0@adventure-works.com | Kevin Brown | 150-555-0189 | 253022876 | Kevin | M | 2018-02-18 | Brown | adventure-works\kevin0 | S | F | 7 | 2 | 150-555-0189 | | 41 | 2018-02-18 | Current | Marketing Assistant | 42 |
| 48 | 14.4231 | 1998-06-13 | Marketing | sariya0@adventure-works.com | Sariya Harnpadoungsataya | 399-555-0176 | 95958330 | Sariya | M | 2020-01-05 | Harnpadoungsataya | adventure-works\sariya0 | S | E | 7 | 2 | 399-555-0176 | | 42 | 2020-01-05 | Current | Marketing Specialist | 45 |
| 109 | 14.4231 | 1973-10-06 | Marketing | mary0@adventure-works.com | Mary Gibson | 531-555-0183 | 767955365 | Mary | F | 2020-02-05 | Gibson | adventure-works\mary0 | M | E | 7 | 2 | 531-555-0183 | | 43 | 2020-02-05 | Current | Marketing Specialist | 46 |
| 122 | 14.4231 | 1990-07-11 | Marketing | jill0@adventure-works.com | Jill Williams | 510-555-0121 | 72636981 | Jill | F | 2020-02-11 | Williams | adventure-works\jill0 | M | A | 7 | 2 | 510-555-0121 | | 43 | 2020-02-11 | Current | Marketing Specialist | 47 |
| 273 | 13.4615 | 1986-04-09 | Marketing | wanida0@adventure-works.com | Wanida Benshoof | 708-555-0141 | 323403273 | Wanida | F | 2022-01-30 | Benshoof | adventure-works\wanida0 | M | M | 7 | 2 | 708-555-0141 | | 40 | 2022-01-30 | Current | Marketing Assistant | 41 |
| 207 | 14.4231 | 1997-02-27 | Marketing | terry0@adventure-works.com | Terry Eminhizer | 138-555-0118 | 243322160 | Terry | M | 2020-03-25 | Eminhizer | adventure-works\terry0 | M | J | 7 | 2 | 138-555-0118 | | 42 | 2020-03-25 | Current | Marketing Specialist | 44 |
| 275 | 14.4231 | 1989-03-29 | Marketing | john5@adventure-works.com | John Wood | 486-555-0150 | 222969461 | John | M | 2022-03-02 | Wood | adventure-works\john5 | S | L | 7 | 2 | 486-555-0150 | | 44 | 2022-03-02 | Current | Marketing Specialist | 48 |
| 276 | 13.4615 | 1989-02-21 | Marketing | mary2@adventure-works.com | Mary Dempsey | 124-555-0114 | 52541318 | Mary | F | 2022-03-09 | Dempsey | adventure-works\mary2 | S | A | 7 | 2 | 124-555-0114 | | 41 | 2022-03-09 | Current | Marketing Assistant | 43 |
Generated 2025-07-23 09:52:34.542 UTC